package com.ruoyi.domain;

import com.alibaba.excel.annotation.format.NumberFormat;
import com.ruoyi.common.annotation.Excel;
import lombok.Data;

import java.math.BigDecimal;

/**
 * 拖柜成本核算
 *
 * @Author:zzm
 * @Date: 2024/8/29 21:07
 */
@Data
public class DraggingCabinet {

    private static final long serialVersionUID = 1L;

    /**
     *入库时间
     */
    @Excel(name = "入库时间")
    private String storageTime;

    /**
     *客户名称
     */
    @Excel(name = "客户名称")
    private String name;

    /**
     *客户编码
     */
    @Excel(name = "客户编码")
    private String code;

    /**
     *仓库
     */
    @Excel(name = "仓库")
    private String wareHouse;

    /**
     *提单号
     */
    @Excel(name = "提单号")
    private String BLNum;

    /**
     *柜号
     */
    @Excel(name = "柜号")
    private String cabinetNumber;

    /**
     *箱数(CTNS)
     */
    @Excel(name = "箱数(CTNS)")
    private String cases;

    /**
     *重量(LB)
     */
    @Excel(name = "重量(LB)")
    private BigDecimal weight;

    /**
     *CBM
     */
    @Excel(name = "CBM")
    private String CBM;

    /**
     *清关师
     */
    @Excel(name = "清关师")
    private String customsClearanceSpecialist;

    /**
     *DEST目的地
     */
    @Excel(name = "DEST目的地")
    private String destination;

    /**
     *派送方式
     */
    @Excel(name = "派送方式")
    private String deliveryMethod;

    /**
     *报关费
     */
    @Excel(name = "报关费")
    @NumberFormat("#0.00")
    private BigDecimal customsCharges;

    /**
     *操作费
     */
    @Excel(name = "操作费")
    @NumberFormat("#0.00")
    private BigDecimal operationFee;

    /**
     *抬头使用费
     */
    @Excel(name = "抬头使用费")
    @NumberFormat("#0.00")
    private BigDecimal headFee;

    /**
     *安全申报
     */
    @Excel(name = "安全申报")
    @NumberFormat("#0.00")
    private BigDecimal securityFiling;

    /**
     *关税
     */
    @Excel(name = "关税")
    @NumberFormat("#0.00")
    private BigDecimal tariff;

    /**
     *多品名费
     */
    @Excel(name = "多品名费")
    @NumberFormat("#0.00")
    private BigDecimal multiProductNameFee;

    /**
     *FDA
     */
    @Excel(name = "FDA")
    @NumberFormat("#0.00")
    private BigDecimal FDA;

    /**
     *货代费
     */
    @Excel(name = "货代费")
    @NumberFormat("#0.00")
    private BigDecimal freightForwardingFee;

    /**
     * 垫付手续费
     */
    @Excel(name = "垫付手续费")
    @NumberFormat("#0.00")
    private BigDecimal advancePaymentOfHandlingFee;

    /**
     *周末加班费
     */
    @Excel(name = "周末加班费")
    @NumberFormat("#0.00")
    private BigDecimal weekendOvertimeFree;

    /**
     *查验费
     */
    @Excel(name = "查验费")
    @NumberFormat("#0.00")
    private BigDecimal inspectionFee;

    /**
     *查验操作费
     */
    @Excel(name = "查验操作费")
    @NumberFormat("#0.00")
    private BigDecimal inspectionOperationFee;

    /**
     *修补费
     */
    @Excel(name = "修补费")
    @NumberFormat("#0.00")
    private BigDecimal RepairFee;

    /**
     *提货费
     */
    @Excel(name = "提货费")
    @NumberFormat("#0.00")
    private BigDecimal pickUpCharge;

    /**
     *疏港费
     */
    @Excel(name = "疏港费")
    @NumberFormat("#0.00")
    private BigDecimal pierPassFee;

    /**
     *车架使用费
     */
    @Excel(name = "车架使用费")
    @NumberFormat("#0.00")
    private BigDecimal chassisFee;

    /**
     *清洁费
     */
    @Excel(name = "清洁费")
    @NumberFormat("#0.00")
    private BigDecimal cleaningFee;

    /**
     *滞期费
     */
    @Excel(name = "滞期费")
    @NumberFormat("#0.00")
    private BigDecimal demurrageCharges;

    /**
     *箱使费
     */
    @Excel(name = "箱使费")
    @NumberFormat("#0.00")
    private BigDecimal perDiemFree;

    /**
     *预提费
     */
    @Excel(name = "预提费")
    @NumberFormat("#0.00")
    private BigDecimal prePullFee;

    /**
     *过夜费
     */
    @Excel(name = "过夜费")
    @NumberFormat("#0.00")
    private BigDecimal yardStorageFee;

    /**
     *drop load费
     */
    @Excel(name = "drop load费")
    @NumberFormat("#0.00")
    private BigDecimal dropLoadFee;

    /**
     *等候费
     */
    @Excel(name = "等候费")
    @NumberFormat("#0.00")
    private BigDecimal waitFree;

    /**
     *底盘分离费
     */
    @Excel(name = "底盘分离费")
    @NumberFormat("#0.00")
    private BigDecimal chassisSeparationFee;

    /**
     *超重费
     */
    @Excel(name = "超重费")
    @NumberFormat("#0.00")
    private BigDecimal overweightFee;

    /**
     *加急费
     */
    @Excel(name = "加急费")
    @NumberFormat("#0.00")
    private BigDecimal emergencyChargesFee;

    /**
     * 其他费用
     */
    @Excel(name = " 其他费用")
    @NumberFormat("#0.00")
    private BigDecimal otherFee;

    /**
     *入库费
     */
    @Excel(name = "入库费")
    @NumberFormat("#0.00")
    private BigDecimal inboundFee;

    /**
     *拆柜费
     */
    @Excel(name = "拆柜费")
    @NumberFormat("#0.00")
    private BigDecimal devanningFee;

    /**
     *打托费
     */
    @Excel(name = "打托费")
    @NumberFormat("#0.00")
    private BigDecimal palletizingFee;

    /**
     *派送费
     */
    @Excel(name = "派送费")
    @NumberFormat("#0.00")
    private BigDecimal shipFee;

    /**
     *出库费
     */
    @Excel(name = "出库费")
    @NumberFormat("#0.00")
    private BigDecimal loadingFee;

    /**
     *预约服务费
     */
    @Excel(name = "预约服务费")
    @NumberFormat("#0.00")
    private BigDecimal serviceFee;

    /**
     *自提费
     */
    @Excel(name = "自提费")
    @NumberFormat("#0.00")
    private BigDecimal pickUpByCustomer;

    /**
     *存柜仓储费
     */
    @Excel(name = "存柜仓储费")
    @NumberFormat("#0.00")
    private BigDecimal wareHouseStorage;

    /**
     *贴标/换标
     */
    @Excel(name = "贴标/换标")
    @NumberFormat("#0.00")
    private BigDecimal label;

    /**
     *拣货费
     */
    @Excel(name = "拣货费")
    @NumberFormat("#0.00")
    private BigDecimal sortingFee;

    /**
     *打包费
     */
    @Excel(name = "打包费")
    @NumberFormat("#0.00")
    private BigDecimal packingFee;

    /**
     *订单处理费
     */
    @Excel(name = "订单处理费")
    @NumberFormat("#0.00")
    private BigDecimal fulfillmentFee;

    /**
     *二次打托费
     */
    @Excel(name = "二次打托费")
    @NumberFormat("#0.00")
    private BigDecimal repallatizingFee;

    /**
     *调减/折扣/赔偿等费用
     */
    @Excel(name = "调减/折扣/赔偿等费用")
    @NumberFormat("#0.00")
    private BigDecimal discountFee;

    /**
     *total
     */
    @Excel(name = "total")
    @NumberFormat("#0.00")
    private BigDecimal total;

    /**
     *备注
     */
    @Excel(name = "备注")
    private String notes;

    /**
     *提货费-客户
     */
    @Excel(name = "提货费-客户")
    @NumberFormat("#0.00")
    private BigDecimal pickUpChargeCustomer;

    /**
     *疏港费
     */
    @Excel(name = "疏港费-客户")
    @NumberFormat("#0.00")
    private BigDecimal pierPassFeeCustomer;

    /**
     *车架使用费
     */
    @Excel(name = "车架使用费-客户")
    @NumberFormat("#0.00")
    private BigDecimal chassisFeeCustomer;

    /**
     *清洁费
     */
    @Excel(name = "清洁费-客户")
    @NumberFormat("#0.00")
    private BigDecimal cleaningFeeCustomer;

    /**
     *滞期费
     */
    @Excel(name = "滞期费-客户")
    @NumberFormat("#0.00")
    private BigDecimal demurrageChargesCustomer;

    /**
     *箱使费
     */
    @Excel(name = "箱使费-客户")
    @NumberFormat("#0.00")
    private BigDecimal perDiemFreeCustomer;

    /**
     *预提费
     */
    @Excel(name = "预提费-客户")
    @NumberFormat("#0.00")
    private BigDecimal prePullFeeCustomer;

    /**
     *过夜费
     */
    @Excel(name = "过夜费-客户")
    @NumberFormat("#0.00")
    private BigDecimal yardStorageFeeCustomer;

    /**
     *drop load费
     */
    @Excel(name = "drop load费-客户")
    @NumberFormat("#0.00")
    private BigDecimal dropLoadFeeCustomer;

    /**
     *等候费
     */
    @Excel(name = "等候费-客户")
    @NumberFormat("#0.00")
    private BigDecimal waitFreeCustomer;

    /**
     *底盘分离费
     */
    @Excel(name = "底盘分离费-客户")
    @NumberFormat("#0.00")
    private BigDecimal chassisSeparationFeeCustomer;

    /**
     *超重费
     */
    @Excel(name = "超重费-客户")
    @NumberFormat("#0.00")
    private BigDecimal overweightFeeCustomer;

    /**
     *加急费
     */
    @Excel(name = "加急费-客户")
    @NumberFormat("#0.00")
    private BigDecimal emergencyChargesFeeCustomer;

    /**
     * 其他费用
     */
    @Excel(name = "其他费用-客户")
    @NumberFormat("#0.00")
    private BigDecimal otherFeeCustomer;

    /**
     * 发票成本
     */
    @Excel(name = "合计成本")
    @NumberFormat("#0.00")
    private BigDecimal invoice;

    /**
     * PDF总金额
     */
    @Excel(name = "pdf名称中的金额")
    @NumberFormat("#0.00")
    private BigDecimal profit;

    /**
     * 错误批注
     */
    @Excel(name = "错误批注")
    private String remarks;

    /**
     * 利润
     */
    @Excel(name = "利润")
    @NumberFormat("#0.00")
    private BigDecimal margin;

    /**
     * 结果
     */
    @Excel(name = "结果")
    private String result;


}
